Querying by Select Clause

This topic describes the procedure to create a query data for the Select clause.

When you build a query, you have select the attributes as a Select clause on which you have to build the query.

1. To add fields to the Select clause, click Select box. The Select box gets the focus, indicated by the highlighted titlebar.
   Note: By default, the Select window is highlighted.
   
2. Add the required fields to the Select box. Double-click the field. This adds that particular field to the Select clause. If you are adding only EmployeeID from the fields list, the Select query box appears as: EmployeeID. The selected field or fields are populated into the Select box.
   Note: You can add various expressions for each field in the Select clause. It is mandatory to use 'Aggregate Functions' expression to build a Select query.
   Query data for the Select clause is created.